package com.tengju.data.infrastructure.persistence.mybatis.mapper.clickhouse.crm;

import com.tengju.data.infrastructure.persistence.mybatis.dataobject.BrandMarketSortDO;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;
import java.util.List;

public interface BrandMarketSortMapper {

    List<BrandMarketSortDO> getBrandMarketSort(@Param("idCodeList") List<Long> idCodeList,
                                               @Param("dateType") Integer dateType,
                                               @Param("minGmv") BigDecimal minGmv,
                                               @Param("maxGmv") BigDecimal maxGmv,
                                               @Param("currentMonthDate") String currentMonthDate,
                                               @Param("lastMonthDate") String lastMonthDate,
                                               @Param("quarterMonthList") List<String> quarterMonthList,
                                               @Param("orderColumn") String orderColumn,
                                               @Param("orderType") String orderType,
                                               @Param("offset") int offset,
                                               @Param("limit") int limit);



    int getBrandMarketCount(@Param("idCodeList") List<Long> idCodeList,
                            @Param("dateType") Integer dateType,
                            @Param("minGmv") BigDecimal minGmv,
                            @Param("maxGmv") BigDecimal maxGmv,
                            @Param("currentMonthDate") String currentMonthDate,
                            @Param("lastMonthDate") String lastMonthDate,
                            @Param("quarterMonthList") List<String> quarterMonthList);

}
